# Prerequisites

The following section lists the prerequisites for working with Qlik Replicate and an Amazon RDS for PostgreSQL source.

## Client prerequisites

### Replicate for Windows

PostgreSQL ODBC Driver psqlodbc\_13\_xx\_xxxx-x64 must be installed on the Replicate machine.

Information noteMake sure that the psql.exe path (e.g. "C:\Program Files\PostgreSQL\13xx\bin") is added to the system PATH.

### Replicate for Linux

Download PostgreSQL 13 ODBC driver, and client programs and libraries.

* Example PostgreSQL ODBC file name: postgresql13-odbc-13.02.0000-1PGDG.rhel8.x86\_64.rpm
* PostgreSQL client programs and libraries file name: postgresql13-13.8-1PGDG.rhel<version>.x86\_64.rpm

Then, open a shell prompt and do the following:

1. Stop the Replicate service and optionally confirm that it has stopped as described in [Replicate server procedures](https://help.qlik.com/en-US/replicate/November2024/Content/Replicate/Main/Installation/Server_Procedures.htm).

2. Install PostgreSQL 13 client programs and libraries.

3. Install the ODBC driver for PostgreSQL 13.

4. Change the working directory to <Replicate-Install-Dir>/bin.

5. Copy the driver location to the `site_arep_login.sh` file:

   `echo "export LD_LIBRARY_PATH=\$LD_LIBRARY_PATH:/usr/lib:/usr/lib64:/usr/pgsql-13/lib" >> site_arep_login.sh`

   This will add the driver to "LD\_LIBRARY\_PATH" and update the driver location in the site\_arep\_login.sh file.

6. Optionally, confirm that the driver location was copied:

   ```
   cat site_arep_login.sh
                           
   ```

7. Makes sure that the `/etc/odbcinst.ini` file contains an entry for PostgreSQL, as in the following example:

   `[PostgreSQL]`

   `Description = PostgreSQL ODBC driver`

   `Driver = /usr/pgsql-13/lib/psqlodbc.so`

   `Setup = /usr/pgsql-13/lib/psqlodbcw.so`

   `UsageCount = 1`

8. Start the Replicate service and optionally confirm that it has started as described in [Replicate server procedures](https://help.qlik.com/en-US/replicate/November2024/Content/Replicate/Main/Installation/Server_Procedures.htm).

## Apply changes prerequisites

When the Apply Changes task option is enabled, the user specified in the Amazon RDS for PostgreSQL source endpoint’s **General** tab must be granted super-user permissions.